/*
 Navicat Premium Data Transfer

 Source Server         : 01-aliyun-mysql-example-app
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.99.145.119:3308
 Source Schema         : traffic

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 20/10/2021 10:30:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for traffic_cameras
-- ----------------------------
DROP TABLE IF EXISTS `traffic_cameras`;
CREATE TABLE `traffic_cameras` (
  `id` int NOT NULL AUTO_INCREMENT,
  `camera_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `camera_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `camera_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `camera_lonlat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camera_road_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `camera_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `camera_scene` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camera_video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camera_original_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camera_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of traffic_cameras
-- ----------------------------
BEGIN;
INSERT INTO `traffic_cameras` VALUES (4, 'f483939b-6534-40d8-91c8-00329fe21100', '珠山湖大道和枫树二路交叉口北侧监控摄像头', '枪球机', '', '0add4d', 'north', '', '', 'http://39.99.145.119:17000/api/traffic_files/previewfile/north.png', '', '2021-09-15 17:24:17', '2021-09-18 15:04:52');
INSERT INTO `traffic_cameras` VALUES (5, '18a6ee1a-4473-4c10-aaa9-96c1518fc3ec', '珠山湖大道和枫树二路交叉口南侧监控摄像头', '枪球机', '', '0add4d', 'south', '', '', 'http://39.99.145.119:17000/api/traffic_files/previewfile/south.png', '', '2021-09-15 17:25:14', '2021-09-15 17:21:03');
INSERT INTO `traffic_cameras` VALUES (6, '1225b79e-45ee-42dd-891f-c072d8d0bfb6', '珠山湖大道和枫树二路交叉口东侧监控摄像头', '枪球机', '', '0add4d', 'east', '', '', 'http://39.99.145.119:17000/api/traffic_files/previewfile/east.png', '', '2021-09-15 17:26:13', '2021-09-15 17:21:03');
INSERT INTO `traffic_cameras` VALUES (7, 'a1ac4db4-8bee-4267-8d0a-71d2f2552c1a', '珠山湖大道和枫树二路交叉口西侧监控摄像头', '枪球机', '', '0add4d', 'west', '', '', 'http://39.99.145.119:17000/api/traffic_files/previewfile/west.png', '', '2021-09-15 17:26:36', '2021-09-15 17:21:03');
COMMIT;

-- ----------------------------
-- Table structure for traffic_event_code
-- ----------------------------
DROP TABLE IF EXISTS `traffic_event_code`;
CREATE TABLE `traffic_event_code` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of traffic_event_code
-- ----------------------------
BEGIN;
INSERT INTO `traffic_event_code` VALUES (1, '2001', '车辆逆行', '2021-09-10 17:08:47', '2021-09-10 18:22:37');
INSERT INTO `traffic_event_code` VALUES (3, '2002', '违章停车', '2021-09-10 18:22:54', '2021-09-10 18:22:54');
INSERT INTO `traffic_event_code` VALUES (4, '2003', '道路拥堵', '2021-09-10 18:23:06', '2021-09-10 18:23:06');
INSERT INTO `traffic_event_code` VALUES (5, '2004', '道路缓行', '2021-09-10 18:23:18', '2021-09-10 18:23:18');
INSERT INTO `traffic_event_code` VALUES (6, '2006', '行人入侵', '2021-09-10 18:23:28', '2021-09-10 18:23:28');
INSERT INTO `traffic_event_code` VALUES (7, '2005', '异常变道', '2021-09-10 18:23:48', '2021-09-10 18:23:48');
INSERT INTO `traffic_event_code` VALUES (8, '2007', '抛洒物', '2021-09-10 18:24:11', '2021-09-10 18:24:11');
INSERT INTO `traffic_event_code` VALUES (9, '2008', '占用应急车道', '2021-09-15 17:21:54', '2021-09-15 17:21:54');
INSERT INTO `traffic_event_code` VALUES (10, '2009', '占用公交车道', '2021-09-15 17:22:21', '2021-09-15 17:22:21');
COMMIT;

-- ----------------------------
-- Table structure for traffic_lane_code
-- ----------------------------
DROP TABLE IF EXISTS `traffic_lane_code`;
CREATE TABLE `traffic_lane_code` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lane_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lane_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of traffic_lane_code
-- ----------------------------
BEGIN;
INSERT INTO `traffic_lane_code` VALUES (1, '1001', '左转车道', '2021-09-10 17:18:54', '2021-09-10 18:18:12');
INSERT INTO `traffic_lane_code` VALUES (3, '1002', '右转车道', '2021-09-10 18:18:26', '2021-09-10 18:18:26');
INSERT INTO `traffic_lane_code` VALUES (4, '1003', '直行车道', '2021-09-10 18:18:39', '2021-09-10 18:18:39');
INSERT INTO `traffic_lane_code` VALUES (5, '1004', '左转和直行车道', '2021-09-10 18:18:54', '2021-09-10 18:18:54');
INSERT INTO `traffic_lane_code` VALUES (6, '1005', '右转和直行车道', '2021-09-10 18:19:09', '2021-09-10 18:19:09');
INSERT INTO `traffic_lane_code` VALUES (7, '1006', '全向车道', '2021-09-10 18:19:47', '2021-09-10 18:19:47');
INSERT INTO `traffic_lane_code` VALUES (10, '1009', '非机动车道', '2021-09-10 18:21:04', '2021-09-10 18:21:04');
COMMIT;

-- ----------------------------
-- Table structure for traffic_road
-- ----------------------------
DROP TABLE IF EXISTS `traffic_road`;
CREATE TABLE `traffic_road` (
  `id` int NOT NULL AUTO_INCREMENT,
  `road_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `road_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `road_lonlat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `traffic_road_road_id` (`road_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of traffic_road
-- ----------------------------
BEGIN;
INSERT INTO `traffic_road` VALUES (4, '0add4d', '硃山湖大道和枫树二路交叉口', '114.134965,30.466782', '2021-09-15 17:19:35', '2021-09-15 17:19:46');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hashed_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '刘兰11英', '', 'ju11n02@example.net', '6d091a8c-314b-11ec-bfd0-acde48001122', '$2b$12$BVm1A/CbMPiWQiDkvwt5m.', '$2b$12$vlC/AqiJB0UNKvvIAWVlFOzy0YYX9sVR2xKSbwhWqMZ0dZfwZxlii', '个人简介：6d091e', '', '2021-10-20 10:14:34', '2021-10-20 10:14:34');
INSERT INTO `user` VALUES (2, '刘11兰11英', '', 'ju1111n02@example.net', '6d091a8c-314b-11ec-bfd0-acde48001122', '$2b$12$KpMrdIe0u2.80G7nTHve5.', '$2b$12$p6hIzvnt.3DAvjRMvcKiWOobHQb5HbwIyQHMGokQwamaGOud8ccv6', '个人简介：6d091e', '', '2021-10-20 10:15:13', '2021-10-20 10:15:13');
INSERT INTO `user` VALUES (3, '李东', '', 'li89@example.com', '77457fee-314c-11ec-b166-acde48001122', '$2b$12$GqNN.i9mgNJdcV4ngdC/Au', '$2b$12$WQrEUsqfCjQBy3lePzwX7.NoPgKHVyw/u/ch6NEpxXxmgHN7m0Cia', '个人简介：774585', '', '2021-10-20 10:22:53', '2021-10-20 10:22:53');
INSERT INTO `user` VALUES (4, '蒋桂芝', '', 'li98@example.com', '50e5d3ca-314d-11ec-81d2-acde48001122', '$2b$12$nYmq6HJIEztf2s0R5cYaJO', '$2b$12$93W8hCgGXAE5KFAi5ZEusuZSznKZiBATYZnOXZ9zdC0PRKZmMLBPq', '个人简介：50e5d7', '', '2021-10-20 10:28:02', '2021-10-20 10:28:02');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
